package MaintMenu.VenPricingUpdMasterFiles;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

// Decompiled by Jad v1.5.8g. Copyright 2001 Pavel Kouznetsov.
// Jad home page: http://www.kpdus.com/jad.html
// Decompiler options: packimports(3)
// Source File Name:   AddNewPartLI.java
//############### STILL TESTING ##########


// Referenced classes of package pk1:
//            DnkFunctions

public class AlterTable {

    public AlterTable(){

        try {
            //DnkFunctions dnk = new DnkFunctions();
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String dataSourceName = "dbli";
            String dbURL = (new StringBuilder()).append("jdbc:odbc:").append(dataSourceName).toString();
            Connection con = DriverManager.getConnection(dbURL, "", "");
            Statement st = con.createStatement();

            try {

//                st.execute("alter table mirrorm1 add DEPO_NO CHAR(15)");
//                st.execute("alter table mirrorm1 add DEPO_PRC double");
//                st.execute("alter table mirrorm1 add DEPO_PKG int");
//                st.execute("alter table coolngm add DEPO_NO CHAR(15)");
//                st.execute("alter table coolngm add DEPO_PRC double");
//                st.execute("alter table coolng1 add DEPO_PKG int");
//
                st.execute("alter table TBLBCN_TEMPOUT  alter column supplier text(10)");
                st.execute("alter table TBLBCN_TEMPOUT2 alter column supplier text(10)");

                st.execute("alter table TBLMRN_TEMPOUT  alter column supplier text(10)");
                st.execute("alter table TBLMRN_TEMPOUT2 alter column supplier text(10)");

                st.execute("alter table TBLOTN_TEMPOUT  alter column supplier text(10)");
                st.execute("alter table TBLOTN_TEMPOUT2 alter column supplier text(10)");

                st.execute("alter table TBLCLN_TEMPOUT  alter column supplier text(10)");
                st.execute("alter table TBlCLN_TEMPOUT2 alter column supplier text(10)");

                st.execute("alter table TBLHFN_TEMPOUT  alter column supplier text(10)");
                st.execute("alter table TBLHFN_TEMPOUT2 alter column supplier text(10)");

                st.execute("alter table TBLLTN_TEMPOUTLI  alter column supplier text(10)");
                st.execute("alter table TBLLTN_TEMPOUTLI2 alter column supplier text(10)");

                st.execute("alter table TBLLTN_TEMPOUTBL  alter column supplier text(10)");
                st.execute("alter table TBLLTN_TEMPOUTBK2 alter column supplier text(10)");

//                st.execute("alter table mirrorm11 add DEPO_NO CHAR(15)");
//                st.execute("alter table mirrorm11 add DEPO_PRC double");
//                st.execute("alter table mirrorm11 add DEPO_PKG int");

            }
            catch(SQLException er) {
                er.printStackTrace();
                System.out.println(er);
            }

            st.close();

            con.close();
        }
        catch(Exception e) {
            e.printStackTrace();
            System.out.println(e);
        }
    }
}
